How to: Add a new field to a table in the Datasheet view.
Solution:
Select the 'Insert' menu and select 'Column', rename the column, and type data in the new field column.
1) If the Database window is not active, activate the Database window.
2) Open the table in the Table Datasheet view.
3) Place the insertion point to the left of the column in front of which the column is to be inserted.
4) Select the 'Insert' menu and select 'Column'. (A column titled Field# appears, where # is 1 if it is the first new column inserted, 2 if it is the second, and so on.)
5) Select the column by clicking on the 'Field Selector'. (The entire column is highlighted.)
Field Selector
6) Select the 'Format' menu and select 'Rename Column'. (The column heading is highlighted.)
7) Type the name for the new field.
8) Press ENTER.
9) Type the desired data in the new field column.
10) Select the 'File' menu and select 'Save Layout'.
11) Select the 'File' menu and select 'Close'.
